Pro T-SQL 2022 by Elizabeth Noble

Author:Elizabeth Noble
Language: eng
Format: epub
ISBN: 9781484292563
Publisher: Apress

Listing 9-4Inserting a Record into dbo.Customer

In Listing 9-4, an explicit transaction has been started using BEGIN TRAN, but it has not specified a COMMIT or ROLLBACK. This will leave the transaction open with a lock on dbo.Customer. To simulate application performance, let’s open a separate query window and run a query to find all records created in this table after October 1, 2022. You can see a sample of this query in Listing 9-5.SELECT FirstName, LastName, Country

FROM dbo.Customer

WHERE DateCreated > '2022-10-01';

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.